import lombok.extern.slf4j.Slf4j;

import java.sql.*;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

@Slf4j
public class App {

    public static void main(String args[]){
        //idea lombok 插件识别
        log.info("hello world\r\n I missssss.....s..s");
    }
    public static void main1(String args[]) throws SQLException {
        String JDBC_URL = "jdbc:oracle:thin:@192.168.0.100:1521/orcl";
        String JDBC_USER = "jxgtjy";
        String JDBC_PASSWORD = "jxgtjy";

        try(Connection conn = DriverManager.getConnection(JDBC_URL, JDBC_USER, JDBC_PASSWORD)){
            try(PreparedStatement stmt = conn.prepareStatement("select * from tbl_landinfo where landinfoid=?")){
                stmt.setObject(1, 37249);
                ResultSet rs =  stmt.executeQuery();
                while(rs.next()){
                    Long id = rs.getLong(1);
                    String useto = rs.getString("F_USETO");
                    System.out.println(id);
                    System.out.println(useto);


                }
            }
        }




    }
}
